﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CADISDSF1005" targetNamespace="http://tempuri.org/CADISDSF1005.xsd" xmlns:mstns="http://tempuri.org/CADISDSF1005.xsd" xmlns="http://tempuri.org/CADISDSF1005.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="CADISConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CADISConnectionString1 (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.JLD004_Interface_M3_Cadis.My.MySettings.GlobalReference.Default.CADISConnectionString1" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="F1005TableAdapter" GeneratorDataComponentClassName="F1005TableAdapter" Name="F1005" UserDataComponentName="F1005TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CADISConnectionString1 (MySettings)" DbObjectName="CADIS.dbo.F1005" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[F1005] WHERE (([JLID] = @Original_JLID) AND ((@IsNull_JLTDAY = 1 AND [JLTDAY] IS NULL) OR ([JLTDAY] = @Original_JLTDAY)) AND ((@IsNull_JLITNO = 1 AND [JLITNO] IS NULL) OR ([JLITNO] = @Original_JLITNO)) AND ((@IsNull_JLDSC1 = 1 AND [JLDSC1] IS NULL) OR ([JLDSC1] = @Original_JLDSC1)) AND ((@IsNull_JLQTY = 1 AND [JLQTY] IS NULL) OR ([JLQTY] = @Original_JLQTY)) AND ((@IsNull_JLUOM = 1 AND [JLUOM] IS NULL) OR ([JLUOM] = @Original_JLUOM)) AND ((@IsNull_JLIDm = 1 AND [JLIDm] IS NULL) OR ([JLIDm] = @Original_JLIDm)) AND ((@IsNull_JLAUF = 1 AND [JLAUF] IS NULL) OR ([JLAUF] = @Original_JLAUF)) AND ((@IsNull_JLTYP = 1 AND [JLTYP] IS NULL) OR ([JLTYP] = @Original_JLTYP)) AND ((@IsNull_JLNUM = 1 AND [JLNUM] IS NULL) OR ([JLNUM] = @Original_JLNUM)) AND ((@IsNull_JLDSERI = 1 AND [JLDSERI] IS NULL) OR ([JLDSERI] = @Original_JLDSERI)) AND ((@IsNull_JLREGION = 1 AND [JLREGION] IS NULL) OR ([JLREGION] = @Original_JLREGION)) AND ((@IsNull_JLTECH = 1 AND [JLTECH] IS NULL) OR ([JLTECH] = @Original_JLTECH)) AND ((@IsNull_JLTECHNAME = 1 AND [JLTECHNAME] IS NULL) OR ([JLTECHNAME] = @Original_JLTECHNAME)) AND ((@IsNull_JLDOYR = 1 AND [JLDOYR] IS NULL) OR ([JLDOYR] = @Original_JLDOYR)) AND ((@IsNull_JLMOYR = 1 AND [JLMOYR] IS NULL) OR ([JLMOYR] = @Original_JLMOYR)) AND ((@IsNull_JLYEAR = 1 AND [JLYEAR] IS NULL) OR ([JLYEAR] = @Original_JLYEAR)) AND ((@IsNull_JLCOST = 1 AND [JLCOST] IS NULL) OR ([JLCOST] = @Original_JLCOST)) AND ((@IsNull_JLPRICE = 1 AND [JLPRICE] IS NULL) OR ([JLPRICE] = @Original_JLPRICE)) AND ((@IsNull_JLBPRICE = 1 AND [JLBPRICE] IS NULL) OR ([JLBPRICE] = @Original_JLBPRICE)) AND ((@IsNull_JLDSC2 = 1 AND [JLDSC2] IS NULL) OR ([JLDSC2] = @Original_JLDSC2)) AND ((@IsNull_JLDSC3 = 1 AND [JLDSC3] IS NULL) OR ([JLDSC3] = @Original_JLDSC3)) AND ((@IsNull_JLDSC4 = 1 AND [JLDSC4] IS NULL) OR ([JLDSC4] = @Original_JLDSC4)) AND ((@IsNull_JLMATH1 = 1 AND [JLMATH1] IS NULL) OR ([JLMATH1] = @Original_JLMATH1)) AND ((@IsNull_JLMATH2 = 1 AND [JLMATH2] IS NULL) OR ([JLMATH2] = @Original_JLMATH2)) AND ((@IsNull_JLMATH3 = 1 AND [JLMATH3] IS NULL) OR ([JLMATH3] = @Original_JLMATH3)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_JLID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="JLID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTDAY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_JLTDAY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLITNO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLITNO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLITNO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLITNO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDSC1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDSC1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDSC1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLQTY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLQTY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLQTY" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLQTY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLUOM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLUOM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLUOM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLUOM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLIDm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLIDm" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLIDm" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLIDm" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLAUF" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLAUF" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLAUF" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLAUF" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTYP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTYP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLTYP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTYP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLNUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLNUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLNUM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLNUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDSERI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDSERI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDSERI" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSERI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLREGION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLREGION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLREGION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLREGION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTECH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTECH" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLTECH" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTECH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTECHNAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTECHNAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLTECHNAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTECHNAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDOYR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDOYR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDOYR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDOYR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLMOYR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLMOYR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLMOYR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLMOYR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLYEAR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLYEAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLCOST" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLCOST" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLCOST" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLCOST" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLPRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLPRICE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLBPRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLBPRICE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLBPRICE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLBPRICE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDSC2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDSC2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDSC2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDSC3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDSC3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDSC3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDSC4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDSC4" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDSC4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC4" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLMATH1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLMATH1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLMATH1" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLMATH1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLMATH2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLMATH2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLMATH2" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLMATH2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLMATH3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLMATH3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLMATH3" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLMATH3" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[F1005] ([JLTDAY], [JLITNO], [JLDSC1], [JLQTY], [JLUOM], [JLIDm], [JLAUF], [JLTYP], [JLNUM], [JLDSERI], [JLREGION], [JLTECH], [JLTECHNAME], [JLDOYR], [JLMOYR], [JLYEAR], [JLCOST], [JLPRICE], [JLBPRICE], [JLDSC2], [JLDSC3], [JLDSC4], [JLMATH1], [JLMATH2], [JLMATH3]) VALUES (@JLTDAY, @JLITNO, @JLDSC1, @JLQTY, @JLUOM, @JLIDm, @JLAUF, @JLTYP, @JLNUM, @JLDSERI, @JLREGION, @JLTECH, @JLTECHNAME, @JLDOYR, @JLMOYR, @JLYEAR, @JLCOST, @JLPRICE, @JLBPRICE, @JLDSC2, @JLDSC3, @JLDSC4, @JLMATH1, @JLMATH2, @JLMATH3);
SELECT JLID, JLTDAY, JLITNO, JLDSC1, JLQTY, JLUOM, JLIDm, JLAUF, JLTYP, JLNUM, JLDSERI, JLREGION, JLTECH, JLTECHNAME, JLDOYR, JLMOYR, JLYEAR, JLCOST, JLPRICE, JLBPRICE, JLDSC2, JLDSC3, JLDSC4, JLMATH1, JLMATH2, JLMATH3 FROM F1005 WHERE (JLID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@JLTDAY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLITNO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLITNO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDSC1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLQTY" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLQTY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLUOM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLUOM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLIDm" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLIDm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLAUF" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLAUF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLTYP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTYP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLNUM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLNUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDSERI" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSERI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLREGION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLREGION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLTECH" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTECH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLTECHNAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTECHNAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDOYR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDOYR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLMOYR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLMOYR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLYEAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLCOST" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLCOST" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLPRICE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLBPRICE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLBPRICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDSC2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDSC3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDSC4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLMATH1" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLMATH1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLMATH2" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLMATH2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLMATH3" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLMATH3" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT JLID, JLTDAY, JLITNO, JLDSC1, JLQTY, JLUOM, JLIDm, JLAUF, JLTYP, JLNUM, JLDSERI, JLREGION, JLTECH, JLTECHNAME, JLDOYR, JLMOYR, JLYEAR, JLCOST, JLPRICE, JLBPRICE, JLDSC2, JLDSC3, JLDSC4, JLMATH1, JLMATH2, JLMATH3 FROM dbo.F1005</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[F1005] SET [JLTDAY] = @JLTDAY, [JLITNO] = @JLITNO, [JLDSC1] = @JLDSC1, [JLQTY] = @JLQTY, [JLUOM] = @JLUOM, [JLIDm] = @JLIDm, [JLAUF] = @JLAUF, [JLTYP] = @JLTYP, [JLNUM] = @JLNUM, [JLDSERI] = @JLDSERI, [JLREGION] = @JLREGION, [JLTECH] = @JLTECH, [JLTECHNAME] = @JLTECHNAME, [JLDOYR] = @JLDOYR, [JLMOYR] = @JLMOYR, [JLYEAR] = @JLYEAR, [JLCOST] = @JLCOST, [JLPRICE] = @JLPRICE, [JLBPRICE] = @JLBPRICE, [JLDSC2] = @JLDSC2, [JLDSC3] = @JLDSC3, [JLDSC4] = @JLDSC4, [JLMATH1] = @JLMATH1, [JLMATH2] = @JLMATH2, [JLMATH3] = @JLMATH3 WHERE (([JLID] = @Original_JLID) AND ((@IsNull_JLTDAY = 1 AND [JLTDAY] IS NULL) OR ([JLTDAY] = @Original_JLTDAY)) AND ((@IsNull_JLITNO = 1 AND [JLITNO] IS NULL) OR ([JLITNO] = @Original_JLITNO)) AND ((@IsNull_JLDSC1 = 1 AND [JLDSC1] IS NULL) OR ([JLDSC1] = @Original_JLDSC1)) AND ((@IsNull_JLQTY = 1 AND [JLQTY] IS NULL) OR ([JLQTY] = @Original_JLQTY)) AND ((@IsNull_JLUOM = 1 AND [JLUOM] IS NULL) OR ([JLUOM] = @Original_JLUOM)) AND ((@IsNull_JLIDm = 1 AND [JLIDm] IS NULL) OR ([JLIDm] = @Original_JLIDm)) AND ((@IsNull_JLAUF = 1 AND [JLAUF] IS NULL) OR ([JLAUF] = @Original_JLAUF)) AND ((@IsNull_JLTYP = 1 AND [JLTYP] IS NULL) OR ([JLTYP] = @Original_JLTYP)) AND ((@IsNull_JLNUM = 1 AND [JLNUM] IS NULL) OR ([JLNUM] = @Original_JLNUM)) AND ((@IsNull_JLDSERI = 1 AND [JLDSERI] IS NULL) OR ([JLDSERI] = @Original_JLDSERI)) AND ((@IsNull_JLREGION = 1 AND [JLREGION] IS NULL) OR ([JLREGION] = @Original_JLREGION)) AND ((@IsNull_JLTECH = 1 AND [JLTECH] IS NULL) OR ([JLTECH] = @Original_JLTECH)) AND ((@IsNull_JLTECHNAME = 1 AND [JLTECHNAME] IS NULL) OR ([JLTECHNAME] = @Original_JLTECHNAME)) AND ((@IsNull_JLDOYR = 1 AND [JLDOYR] IS NULL) OR ([JLDOYR] = @Original_JLDOYR)) AND ((@IsNull_JLMOYR = 1 AND [JLMOYR] IS NULL) OR ([JLMOYR] = @Original_JLMOYR)) AND ((@IsNull_JLYEAR = 1 AND [JLYEAR] IS NULL) OR ([JLYEAR] = @Original_JLYEAR)) AND ((@IsNull_JLCOST = 1 AND [JLCOST] IS NULL) OR ([JLCOST] = @Original_JLCOST)) AND ((@IsNull_JLPRICE = 1 AND [JLPRICE] IS NULL) OR ([JLPRICE] = @Original_JLPRICE)) AND ((@IsNull_JLBPRICE = 1 AND [JLBPRICE] IS NULL) OR ([JLBPRICE] = @Original_JLBPRICE)) AND ((@IsNull_JLDSC2 = 1 AND [JLDSC2] IS NULL) OR ([JLDSC2] = @Original_JLDSC2)) AND ((@IsNull_JLDSC3 = 1 AND [JLDSC3] IS NULL) OR ([JLDSC3] = @Original_JLDSC3)) AND ((@IsNull_JLDSC4 = 1 AND [JLDSC4] IS NULL) OR ([JLDSC4] = @Original_JLDSC4)) AND ((@IsNull_JLMATH1 = 1 AND [JLMATH1] IS NULL) OR ([JLMATH1] = @Original_JLMATH1)) AND ((@IsNull_JLMATH2 = 1 AND [JLMATH2] IS NULL) OR ([JLMATH2] = @Original_JLMATH2)) AND ((@IsNull_JLMATH3 = 1 AND [JLMATH3] IS NULL) OR ([JLMATH3] = @Original_JLMATH3)));
SELECT JLID, JLTDAY, JLITNO, JLDSC1, JLQTY, JLUOM, JLIDm, JLAUF, JLTYP, JLNUM, JLDSERI, JLREGION, JLTECH, JLTECHNAME, JLDOYR, JLMOYR, JLYEAR, JLCOST, JLPRICE, JLBPRICE, JLDSC2, JLDSC3, JLDSC4, JLMATH1, JLMATH2, JLMATH3 FROM F1005 WHERE (JLID = @JLID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@JLTDAY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLITNO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLITNO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDSC1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLQTY" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLQTY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLUOM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLUOM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLIDm" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLIDm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLAUF" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLAUF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLTYP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTYP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLNUM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLNUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDSERI" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSERI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLREGION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLREGION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLTECH" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTECH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLTECHNAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTECHNAME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDOYR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDOYR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLMOYR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLMOYR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLYEAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLCOST" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLCOST" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLPRICE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLBPRICE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLBPRICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDSC2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDSC3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JLDSC4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLMATH1" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLMATH1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLMATH2" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLMATH2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@JLMATH3" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLMATH3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_JLID" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="JLID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTDAY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_JLTDAY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="JLTDAY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLITNO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLITNO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLITNO" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLITNO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDSC1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDSC1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDSC1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLQTY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLQTY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLQTY" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLQTY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLUOM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLUOM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLUOM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLUOM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLIDm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLIDm" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLIDm" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLIDm" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLAUF" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLAUF" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLAUF" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLAUF" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTYP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTYP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLTYP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTYP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLNUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLNUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLNUM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLNUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDSERI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDSERI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDSERI" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSERI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLREGION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLREGION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLREGION" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLREGION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTECH" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTECH" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLTECH" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTECH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLTECHNAME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLTECHNAME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLTECHNAME" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLTECHNAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDOYR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDOYR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDOYR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDOYR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLMOYR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLMOYR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLMOYR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLMOYR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLYEAR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLYEAR" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLYEAR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLCOST" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLCOST" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLCOST" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLCOST" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLPRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLPRICE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLPRICE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLBPRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLBPRICE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLBPRICE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLBPRICE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDSC2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDSC2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDSC2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDSC3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDSC3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDSC3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLDSC4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLDSC4" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JLDSC4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JLDSC4" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLMATH1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLMATH1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLMATH1" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLMATH1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLMATH2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLMATH2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLMATH2" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLMATH2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JLMATH3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JLMATH3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_JLMATH3" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="JLMATH3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="JLID" ColumnName="JLID" DataSourceName="CADIS.dbo.F1005" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@JLID" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="JLID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="JLID" DataSetColumn="JLID" />
              <Mapping SourceColumn="JLTDAY" DataSetColumn="JLTDAY" />
              <Mapping SourceColumn="JLITNO" DataSetColumn="JLITNO" />
              <Mapping SourceColumn="JLDSC1" DataSetColumn="JLDSC1" />
              <Mapping SourceColumn="JLQTY" DataSetColumn="JLQTY" />
              <Mapping SourceColumn="JLUOM" DataSetColumn="JLUOM" />
              <Mapping SourceColumn="JLIDm" DataSetColumn="JLIDm" />
              <Mapping SourceColumn="JLAUF" DataSetColumn="JLAUF" />
              <Mapping SourceColumn="JLTYP" DataSetColumn="JLTYP" />
              <Mapping SourceColumn="JLNUM" DataSetColumn="JLNUM" />
              <Mapping SourceColumn="JLDSERI" DataSetColumn="JLDSERI" />
              <Mapping SourceColumn="JLREGION" DataSetColumn="JLREGION" />
              <Mapping SourceColumn="JLTECH" DataSetColumn="JLTECH" />
              <Mapping SourceColumn="JLTECHNAME" DataSetColumn="JLTECHNAME" />
              <Mapping SourceColumn="JLDOYR" DataSetColumn="JLDOYR" />
              <Mapping SourceColumn="JLMOYR" DataSetColumn="JLMOYR" />
              <Mapping SourceColumn="JLYEAR" DataSetColumn="JLYEAR" />
              <Mapping SourceColumn="JLCOST" DataSetColumn="JLCOST" />
              <Mapping SourceColumn="JLPRICE" DataSetColumn="JLPRICE" />
              <Mapping SourceColumn="JLBPRICE" DataSetColumn="JLBPRICE" />
              <Mapping SourceColumn="JLDSC2" DataSetColumn="JLDSC2" />
              <Mapping SourceColumn="JLDSC3" DataSetColumn="JLDSC3" />
              <Mapping SourceColumn="JLDSC4" DataSetColumn="JLDSC4" />
              <Mapping SourceColumn="JLMATH1" DataSetColumn="JLMATH1" />
              <Mapping SourceColumn="JLMATH2" DataSetColumn="JLMATH2" />
              <Mapping SourceColumn="JLMATH3" DataSetColumn="JLMATH3" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CADISDSF1005" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="CADISDSF1005" msprop:Generator_UserDSName="CADISDSF1005">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="F1005" msprop:Generator_TableClassName="F1005DataTable" msprop:Generator_TableVarName="tableF1005" msprop:Generator_TablePropName="F1005" msprop:Generator_RowDeletingName="F1005RowDeleting" msprop:Generator_UserTableName="F1005" msprop:Generator_RowChangingName="F1005RowChanging" msprop:Generator_RowEvHandlerName="F1005RowChangeEventHandler" msprop:Generator_RowDeletedName="F1005RowDeleted" msprop:Generator_RowEvArgName="F1005RowChangeEvent" msprop:Generator_RowChangedName="F1005RowChanged" msprop:Generator_RowClassName="F1005Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="JLID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnJLID" msprop:Generator_ColumnPropNameInRow="JLID" msprop:Generator_ColumnPropNameInTable="JLIDColumn" msprop:Generator_UserColumnName="JLID" type="xs:long" />
              <xs:element name="JLTDAY" msprop:Generator_ColumnVarNameInTable="columnJLTDAY" msprop:Generator_ColumnPropNameInRow="JLTDAY" msprop:Generator_ColumnPropNameInTable="JLTDAYColumn" msprop:Generator_UserColumnName="JLTDAY" type="xs:dateTime" minOccurs="0" />
              <xs:element name="JLITNO" msprop:Generator_ColumnVarNameInTable="columnJLITNO" msprop:Generator_ColumnPropNameInRow="JLITNO" msprop:Generator_ColumnPropNameInTable="JLITNOColumn" msprop:Generator_UserColumnName="JLITNO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLDSC1" msprop:Generator_ColumnVarNameInTable="columnJLDSC1" msprop:Generator_ColumnPropNameInRow="JLDSC1" msprop:Generator_ColumnPropNameInTable="JLDSC1Column" msprop:Generator_UserColumnName="JLDSC1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLQTY" msprop:Generator_ColumnVarNameInTable="columnJLQTY" msprop:Generator_ColumnPropNameInRow="JLQTY" msprop:Generator_ColumnPropNameInTable="JLQTYColumn" msprop:Generator_UserColumnName="JLQTY" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLUOM" msprop:Generator_ColumnVarNameInTable="columnJLUOM" msprop:Generator_ColumnPropNameInRow="JLUOM" msprop:Generator_ColumnPropNameInTable="JLUOMColumn" msprop:Generator_UserColumnName="JLUOM" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLIDm" msprop:Generator_ColumnVarNameInTable="columnJLIDm" msprop:Generator_ColumnPropNameInRow="JLIDm" msprop:Generator_ColumnPropNameInTable="JLIDmColumn" msprop:Generator_UserColumnName="JLIDm" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLAUF" msprop:Generator_ColumnVarNameInTable="columnJLAUF" msprop:Generator_ColumnPropNameInRow="JLAUF" msprop:Generator_ColumnPropNameInTable="JLAUFColumn" msprop:Generator_UserColumnName="JLAUF" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLTYP" msprop:Generator_ColumnVarNameInTable="columnJLTYP" msprop:Generator_ColumnPropNameInRow="JLTYP" msprop:Generator_ColumnPropNameInTable="JLTYPColumn" msprop:Generator_UserColumnName="JLTYP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLNUM" msprop:Generator_ColumnVarNameInTable="columnJLNUM" msprop:Generator_ColumnPropNameInRow="JLNUM" msprop:Generator_ColumnPropNameInTable="JLNUMColumn" msprop:Generator_UserColumnName="JLNUM" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLDSERI" msprop:Generator_ColumnVarNameInTable="columnJLDSERI" msprop:Generator_ColumnPropNameInRow="JLDSERI" msprop:Generator_ColumnPropNameInTable="JLDSERIColumn" msprop:Generator_UserColumnName="JLDSERI" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLREGION" msprop:Generator_ColumnVarNameInTable="columnJLREGION" msprop:Generator_ColumnPropNameInRow="JLREGION" msprop:Generator_ColumnPropNameInTable="JLREGIONColumn" msprop:Generator_UserColumnName="JLREGION" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLTECH" msprop:Generator_ColumnVarNameInTable="columnJLTECH" msprop:Generator_ColumnPropNameInRow="JLTECH" msprop:Generator_ColumnPropNameInTable="JLTECHColumn" msprop:Generator_UserColumnName="JLTECH" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLTECHNAME" msprop:Generator_ColumnVarNameInTable="columnJLTECHNAME" msprop:Generator_ColumnPropNameInRow="JLTECHNAME" msprop:Generator_ColumnPropNameInTable="JLTECHNAMEColumn" msprop:Generator_UserColumnName="JLTECHNAME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLDOYR" msprop:Generator_ColumnVarNameInTable="columnJLDOYR" msprop:Generator_ColumnPropNameInRow="JLDOYR" msprop:Generator_ColumnPropNameInTable="JLDOYRColumn" msprop:Generator_UserColumnName="JLDOYR" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLMOYR" msprop:Generator_ColumnVarNameInTable="columnJLMOYR" msprop:Generator_ColumnPropNameInRow="JLMOYR" msprop:Generator_ColumnPropNameInTable="JLMOYRColumn" msprop:Generator_UserColumnName="JLMOYR" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLYEAR" msprop:Generator_ColumnVarNameInTable="columnJLYEAR" msprop:Generator_ColumnPropNameInRow="JLYEAR" msprop:Generator_ColumnPropNameInTable="JLYEARColumn" msprop:Generator_UserColumnName="JLYEAR" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLCOST" msprop:Generator_ColumnVarNameInTable="columnJLCOST" msprop:Generator_ColumnPropNameInRow="JLCOST" msprop:Generator_ColumnPropNameInTable="JLCOSTColumn" msprop:Generator_UserColumnName="JLCOST" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLPRICE" msprop:Generator_ColumnVarNameInTable="columnJLPRICE" msprop:Generator_ColumnPropNameInRow="JLPRICE" msprop:Generator_ColumnPropNameInTable="JLPRICEColumn" msprop:Generator_UserColumnName="JLPRICE" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLBPRICE" msprop:Generator_ColumnVarNameInTable="columnJLBPRICE" msprop:Generator_ColumnPropNameInRow="JLBPRICE" msprop:Generator_ColumnPropNameInTable="JLBPRICEColumn" msprop:Generator_UserColumnName="JLBPRICE" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLDSC2" msprop:Generator_ColumnVarNameInTable="columnJLDSC2" msprop:Generator_ColumnPropNameInRow="JLDSC2" msprop:Generator_ColumnPropNameInTable="JLDSC2Column" msprop:Generator_UserColumnName="JLDSC2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLDSC3" msprop:Generator_ColumnVarNameInTable="columnJLDSC3" msprop:Generator_ColumnPropNameInRow="JLDSC3" msprop:Generator_ColumnPropNameInTable="JLDSC3Column" msprop:Generator_UserColumnName="JLDSC3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLDSC4" msprop:Generator_ColumnVarNameInTable="columnJLDSC4" msprop:Generator_ColumnPropNameInRow="JLDSC4" msprop:Generator_ColumnPropNameInTable="JLDSC4Column" msprop:Generator_UserColumnName="JLDSC4" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JLMATH1" msprop:Generator_ColumnVarNameInTable="columnJLMATH1" msprop:Generator_ColumnPropNameInRow="JLMATH1" msprop:Generator_ColumnPropNameInTable="JLMATH1Column" msprop:Generator_UserColumnName="JLMATH1" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLMATH2" msprop:Generator_ColumnVarNameInTable="columnJLMATH2" msprop:Generator_ColumnPropNameInRow="JLMATH2" msprop:Generator_ColumnPropNameInTable="JLMATH2Column" msprop:Generator_UserColumnName="JLMATH2" type="xs:decimal" minOccurs="0" />
              <xs:element name="JLMATH3" msprop:Generator_ColumnVarNameInTable="columnJLMATH3" msprop:Generator_ColumnPropNameInRow="JLMATH3" msprop:Generator_ColumnPropNameInTable="JLMATH3Column" msprop:Generator_UserColumnName="JLMATH3" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:F1005" />
      <xs:field xpath="mstns:JLID" />
    </xs:unique>
  </xs:element>
</xs:schema>